[dbo].[BAECartGetBestShippingRate]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAECartGetBestShippingRate

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@zone	varchar(20)	20
@zone_id	int	4
@weight	money	8

SQL Script

create procedure [dbo].[BAECartGetBestShippingRate] @zone varchar(20),
     @zone_id int,
     @weight money as
SELECT DISTINCT top 1 RATE
    FROM Freight_Rate F JOIN Zone_Code Z
    ON F.SHIP_METHOD = Z.SHIP_METHOD
    WHERE F.SHIP_METHOD = @zone AND ZONE_ID = @zone_id AND WEIGHT >= @weight
    ORDER BY RATE asc

GO

Uses

[dbo].[Freight_Rate]
[dbo].[Zone_Code]
dbo